package com.qf.test.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.qf.test.pojo.DtsOrderGoods;
import com.qf.test.vo.OrederVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 订单商品表 Mapper 接口
 * </p>
 *
 * @author zhaojian
 * @since 2021-05-12
 */
public interface DtsOrderGoodsMapper extends BaseMapper<DtsOrderGoods> {

    /**
     * 查询订单对应的发货模块
     */
   // @Select("SELECT ship_sn `value`,ship_channel label from dts_order where ship_sn is not null ")
    @Select("SELECT  ship_channel label,ship_sn `value`  FROM dts_order GROUP BY ship_channel HAVING ship_channel is NOT NULL")
    //@Select("SELECT ship_sn ,ship_channel  from dts_order")
    public List<OrederVo> findAll();
}
